Optimization of Transaction Database Design with MySQL and MongoDB

نویسندگان

چکیده

Database is one of the most important parts in running an application. Databases can be used to store data. However, application, selection appropriate database needs considered, so that resulting information accordance with user needs. In developing applications, more people use RDBMS design which has a very structured nature, but technological developments have introduced NoSQL as development method. this research, MySQL and MongoDB databases will tested transaction processing. The tests carried out include comparisons designs, defining table structures, time insert, update, delete, search processes. test results show simpler description structure than MySQL. faster difference insert process there 0.005625 sec, update 0.001688 delete 0.00075 sec 0.006875 sec.

برای دانلود باید عضویت طلایی داشته باشید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Flash Game with Mysql Database Development

This research is intended to develop a model of multimedia application, particularly a puzzle game for Interactive Multimedia Course. This model should encourage students to integrate all information resources to develop a multimedia application particularly puzzle game. The puzzle game application generates input and processed data as a server-side with Adobe Flash. Flash is a powerful and dyn...

متن کامل

A hybrid approach for database intrusion detection at transaction and inter-transaction levels

Nowadays, information plays an important role in organizations. Sensitive information is often stored in databases. Traditional mechanisms such as encryption, access control, and authentication cannot provide a high level of confidence. Therefore, the existence of Intrusion Detection Systems in databases is necessary. In this paper, we propose an intrusion detection system for detecting attacks...

متن کامل

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

A Lump-sum Update Method as Transaction in MongoDB

Along with the progress of the cloud computing, it became necessary to deal with various and large quantity data in the distributed database environments. So, the various NoSQL databases have been proposed and put to practical use. However, as for the NoSQL databases, since it supports the distributed environment, the integrity of the database update is basically guaranteed only by the object u...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

ژورنال

عنوان ژورنال: Sinkron : jurnal dan penelitian teknik informatika

سال: 2022

ISSN: ['2541-2019', '2541-044X']

DOI: https://doi.org/10.33395/sinkron.v7i3.11528